home *** CD-ROM | disk | FTP | other *** search
- ISERROR
- Determines whether an error has occurred in evaluating an expression.
-
- Format: ISERROR (value {,error-type})
-
- Arguments:
- ΓÇó value: A numeric or a text expression.
- ΓÇó error-type: Optional. Any of the following predefined errors:
- #N/A! - not available
- #DIV/0! - divide by zero
- #VALUE! - incorrect value
- #NUM! - incorrect number
- #REF! - reference to incorrect cell
- #ARG! - incorrect # of arguments or incorrect argument type
- #USER! - user-defined error
- #DATE! - incorrect date
- #TIME! - incorrect time
- #ERROR! - not a true error
-
- Example:
- ISERROR (K7) returns FALSE.
- Shows that no error was encountered when evaluating cell K7, assuming K7 contains text or a valid number.